package com.mabs.dao;

public interface PersonSQL {
	String INSERT_PERSON = "insert into jdbc_person(name,gender,phone,qq,address) values(?,?,?,?,?)";
	String SELECT_PERSON_BY_ID = "select * from jdbc_person where id=";
	String SELECT_PERSON_BY_PHONE = "select * from jdbc_person where phone=";
	String SELECT_ALL_PERSONS = "select * from jdbc_person";
	String SELECT_PERSON_BY_NAME = "select * from jdbc_person where name like ";
	String DELETE_PERSON_BY_ID = "delete from jdbc_person where id=";
}
